osid

The error is as follows: Wed Oct 21 03:06:22 2015Thread 1 advanced to log sequence 254206 (LGWR switch)Current log# 9 seq# 254206 mem# 0:/boss_sysdata/oradata/dtvboss/redo09.logWed Oct 21 03:17:10 2015Warning:aiowait timed out 1 timesWed Oct 21 03:22:11 2015Errors in FILE/ORACLE/ADMIN/DTVBOSS/BDUMP/DTVBOSS_ARC0_404.TRC:Ora-00494:enqueue [CF] held for too long (more than 900 seconds) by ' Inst 1, osid 367 'Wed Oct 21 03:22:17 2015System state dumped t

Resource Manager plan activeReplication_dependency_tracking turned off (no async multimaster replication found)Starting background process QMNCTue Jul 08 22:53:04 2014QMNC started with pid = 70, OS id = 13956Completed: alter database openTue Jul 08 22:53:05 2014Db_recovery_file_dest_size of 4977 MB is 0.00% used. This isUser-specified limit on the amount of space that will be used by thisDatabase for recovery-related files, and does not reflect the amountSpace available in the underlying filesy

. For example, Hang Management, Resource Manager Idle Blocker Kill, SQL Tune Hang Avoidance and pmon cleanup, and some external tools such as Procwatcher. Let's take a look at the definition of the v $ wait_chains view. Take 11gR2 as an example. SQL> desc v $ wait_chains Name Null? Type ----------------------------------------------------------------------------- CHAIN_ID NUMBER CHAIN_IS_CYCLE VARCHAR2 (5) CHAIN_SIGNATURE VARCHAR2 (801) CHAIN_SIGNATURE_HASH NUMBER INSTANCE NUMBER

: Internal error code, parameters: [Kturpots_0], [], [], [], [], [], [], [], [], [], [], []Incident details in:/oracle/diag/rdbms/xifenfei/xifenfei1/incident/incdir_184348/xifenfei1_ora_18088342_ I184348.trcMon Sep 21 15:56:34 2015Use Adrci or Support Workbench to package the incident.411.1 at my Oracle Support for error and packaging details.Error trapped in 2PC on transaction 7.16.120119. Cleaning up.Error Stack returned to User:ORA-00600: Internal error code, parameters: [Kturpots_0], [], [],

, and the problem lies in the damage to the control file, but for professional personnel, it is obviously impossible to satisfy such a mentality, so we need to analyze it further: However, we can see the following information in the ASM log: Tue Mar 27 13:35:11 2012NOTE: client PROD1: PROD registered, osid 6726, mbr 0x1Tue Mar 27 13:35:24 2012NOTE: ASM client PROD1: PROD disconnected unexpectedly.NOTE: check client alert log.NOTE: Trace records dumped

When the control file is corrupted for databases earlier than Oracle 11g, when we mount the database, there will be a significant ora-600 error, so it is easy to know the control file corruption error, however, oracle 11g R2, At that time, it was an ORACLE 11g RAC system. When a problem occurs, the database instance can be opened by nomount, but the following alarm occurs when the mount control file is mounted: ORA-3113"End of file on communication channel" Then the whole sqlplus connection is t

OCRCHEK22015-09-02 14:06:19.394: [ocrcheck][1069037312]exiting [status=failed] ... There is absolutely no train of thought here, so let's take a closer look at the ASM alert log as follows: Tue Sep 01 23:07:03 2015Note:process _B000_+ASM1 (19088) initiating offline of disk 0.3915955003 (OCR_VOTE01) with mask 0x7e in Group 4Note:process _B000_+ASM1 (19088) initiating offline of disk 1.3915955004 (OCR_VOTE02) with mask 0x7e in Group 4Note:process _B000_+ASM1 (19088) initiating offline of disk 2

ARCH PROCESSES Thu Nov 13 10:13:20 2014 ARC0 started with pid = 21 and OSid = 26949 ARC0: Archival started LGWR: STARTING ARCH PROCESSESCOMPLETE ARC0: STARTING ARCH PROCESSES LGWR: Primary database is inMAXIMUM AVAILABILITY mode LGWR: DestinationLOG_ARCHIVE_DEST_1 is not serviced by LGWR LGWR: Minimum of 1 LGWR standbydatabase required Errors in file/u01/oracle/diag/rdbms/ntracdb/trace/ntracdb_lgwr_26870.trc: The ORA-16072: a minimum of onestandby da

: group DATA2: updated PST location: disk 0001 (PST copy 0)NOTE: group DATA2: updated PST location: disk 0002 (PST copy 1)NOTE: group DATA2: updated PST location: disk 0003 (PST copy 2)NOTE: GMON heartbeating for grp 3GMON querying group 3 at 38for pid 20, osid 7681NOTE: Assigning number (3, 0) to disk ()GMON querying group 3 at 39 for pid 20, object ID 7681NOTE: cache dismounting (clean) group 3/0x62589C78 (DATA2)NOTE: messaging CKPT to quiesce pins

/oracle/oradata/ntracdb/sysaux.257.857772301 '; Set newname for datafile '+ DATA01/ntracdb/datafile/strategy.256.858008275' to '/u01/oracle/oradata/ntracdb/strategy.256.858008275' Restore database; Switch datafile all; Recover database; } -- An error is reported when the database is opened. $ Sqlplus/as sysdba SQL> alter database open; Alter database open * Error in row 1st ORA-03113: End of the file for the communication channel Process ID 6988 Session ID: 191 serial number: 3 -- View log

/rdbms/xxxx/xxxx1/trace/xxxx1_smon_10289168.trc:ORA-00607: Internal error occurred while making a change to a data blockORA-00600: internal error code, arguments: [6856], [0], [1], [], [], [], [], [], [], [], [], [], []Sat Mar 26 19:05:43 2016Dumping diagnostic data in directory = [cdmp_201603261_543], requested by (instance = 1, osid = 10289168 (SMON), summary = [incident = 2400209].Starting background process QMNCSat Mar 26 19:05:44 2016QMNC started

Change the Oracle 11g archive mode on the Win7, describing the errors that may be encountered, as well as the original purpose of writing this blog in order for other channels to avoid the same error, or how to solve the same error guidance, because the command is already clear, so it is not explained in detail. Sql> Conn Sys/oracle@osid as Sysdba is connected. Sql> select instance_name from V$instance; Instance_name -----------------------------

Nov 13 10:13:20 2014ALTER DATABASE OpenData Guard brokerinitializing ...Data Guard brokerinitialization CompleteData guard:verifying databaseprimary role ...Thu Nov 13 10:13:20 2014Lgwr:starting ARCH PROCESSESThu Nov 13 10:13:20 2014ARC0 started with pid=21, osid=26949Arc0:archival startedLgwr:starting ARCH ProcessescompleteArc0:starting ARCH PROCESSESLgwr:primary database is inmaximum availability modeLgwr:destinationlog_archive_dest_1 isn't service

background: Fri Nov 30 18:02:43 2012Errors in file/space/sys_software/oracle/app/diag/rdbms/shvdb/shvdb1/trace/shvdb1_ora_9240854.trc (incident = 48601 ):ORA-00600: internal error code, arguments: [kssadd: null parent], [], [], [], [], [], [], [], [], [], []Incident details in:/space/sys_software/oracle/app/diag/rdbms/shvdb/shvdb1/incident/incdir_48601/shvdb1_ora_9240854_i48601.trcUse ADRCI or Support Workbench to package the incident.See Note 411.1 at My Oracle Support for error and packaging

], [], [], [], [], [], [], [], [], [], []], [], [], [], [], [], [], [], [], []ASMB (ospid:11141424): Terminating the instance due to error 15064Thu Sep 17 11:38:10 2015System State Dump requested by (Instance=1, osid=11141424 (ASMB)), summary=[abnormal instance. Termination].System state dumped to trace FILE/ORACLE/APP/ORACLE/DIAG/RDBMS/CRM2DB/CRM2DB1/TRACE/CRM2DB1_DIAG_12714592.TRCThu Sep 17 11:38:10 2015OPIODR aborting process unknown ospid (2241429

Validation for Group=1Mon Sep 21 19:52:44 2015Note:skipping Rediscovery for group 1/0XB94738F1 (DG_XFF) on the local instance.Note:requesting all-instance Disk Validation for Group=1Note:skipping Rediscovery for group 1/0XB94738F1 (DG_XFF) on the local instance.note:initiating PST update:grp = 1Mon Sep 21 19:52:44 2015Gmon Updating group 1 at-A for-PID, Osid 12124486NOTE:PST Update GRP = 1 completed successfullyNote:membership Refresh pending for gro

poke 0x06001AE70 4 0x859AFAORA-00074: no process has been specifiedSQL> oradebug setmypidStatement processed.SQL> oradebug DUMPvar SGA kcsgscn_kcslf kcsgscn_ [06001AE70, 06001AEA0) = 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 6001AB50 00000000SQL> oradebug poke 0x06001AE70 4 0x859AFABEFORE: [06001AE70, 06001AE74) = 00000000AFTER: [06001AE70, 06001AE74) = 00859AFASQL> alter database open; Database altered. SQL> Here, we will briefly explain

= [cdmp_20140325131526], requested by (instance = 2, osid = 8192018 (LMD0), summary = [abnormal instance termination].Tue Mar 25 13:15:42 2014Reconfiguration started (old inc 50, new inc 54)List of instances:1 (myinst: 1)...Tue Mar 25 13:15:52 2014Archived Log entry 316 added for thread 2 sequence 114 ID 0xffffffff82080958 dest 1:Tue Mar 25 13:15:53 2014ARC3: Archiving disabled thread 2 sequence 115Archived Log entry 317 added for thread 2 sequence 1

status of the current node. Check the error message of the ASM instance: Fri Feb 28 19:41:23 2014Dumping diagnostic data in directory = [cdmp_20130702164115], requested by (instance = 2, osid = 2032294 (LMD0), summary = [incident = 165521].Fri Feb 28 19:49:19 2014Dumping diagnostic data in directory = [cdmp_20130702164845], requested by (instance = 2, osid = 2032294 (LMD0), summary = [incident = 165522].Fr